package com.sp.scmdb.service;

import java.io.File;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.sp.scmdb.bean.AlarmBean;
import com.sp.scmdb.bean.EmpReportBean;
import com.sp.scmdb.bean.LabelIOBean;
import com.sp.scmdb.bean.ReaderBean;
import com.sp.scmdb.bean.UserBean;
import com.sp.scmdb.exception.ExcelException;
import com.sp.scmdb.utils.EmpCollectionGroup;

public interface ExportExcelService {

	public HSSFWorkbook createLabelIOExcel(LabelIOBean labelIOBean) throws ExcelException;

	public HSSFWorkbook createDayReportExcel(EmpReportBean empReportBean, String tableName) throws ExcelException;

	public HSSFWorkbook createMonthReportExcel(EmpReportBean empReportBean, Map<Integer, String> dayOfMonth,
			String tebleName) throws ExcelException;

	public HSSFWorkbook createAlarmReportExcel(AlarmBean alarmBean, String tableName) throws ExcelException;

	public HSSFWorkbook createEmployeeExcel(String tableName) throws ExcelException;

	public HSSFWorkbook createTagExcel(String tableName) throws ExcelException;

	public String importExcel(File file, String fileName, EmpCollectionGroup empGroup, UserBean user);

	public String importTagExcel(File file, String fileName, UserBean user);
	
	public HSSFWorkbook createReaderExcel(ReaderBean readerBean, String tableName) throws ExcelException;

}
